use array formula in excel table. There are any references about use array formula in excel table in here. you can look below.